SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 256311 LIMIT 1 [ RunTime:0.003473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 256311 [ RunTime:0.003329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60858,538936,254120,200808,1036915,812545,195311,320455,661781,951958,93543,683898,423150,1041216,309783,883093,1010879,274542,907068,1019380,261723,999376,633189,350352,585146,990107,485224,159876,400914,499554,808936,392440,205774,712013,635091,337021,259026,287117,902385,1008256,1025429,769169,942613,985804,1018881,999471,421861,219542,748961,882524,551736,538871,604266,668660,384934,741164,261226,456060,372593,131888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 256311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 256311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000773s ]