SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028882 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028882 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289588,1028717,355421,468243,405406,268041,506345,400774,78339,598438,474845,933785,71562,710388,139016,906527,200818,898468,1037371,722071,70413,43833,607237,154615,221855,421954,615741,983911,263926,399742,966125,80309,265803,402109,936420,133378,763964,514621,25489,356135,674735,773817,527632,480649,20665,935847,19704,1048173,555925,234819,211329,723387,145006,39443,567749,375188,964312,616059,427182,998898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001235s ]