SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267683 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267683 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53308,187905,549479,863156,90049,527499,632764,896654,257468,694366,837661,2221,53959,52351,456601,705769,826323,931183,783312,1035900,143649,734694,1044813,603614,824983,204898,313679,66445,146552,183427,889232,268724,1011621,725755,155843,173730,594788,659254,774250,588515,564339,975209,788079,385506,891226,897120,274206,311230,922455,319241,437122,515992,748485,584368,1014775,602366,108510,953539,944840,114013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]