SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003844s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198005 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198005 [ RunTime:0.003707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489633,668906,767824,549997,883810,546770,904556,642090,46473,883344,181592,929680,875006,534830,722004,692060,808925,259564,511913,591000,865592,508743,431372,343863,1044915,18215,683295,517989,895461,788496,620655,391766,456129,89478,332543,839714,282118,954929,502039,403204,836908,344253,191827,600464,895074,933546,499774,538973,610090,653533,227263,342854,235717,124768,296622,517277,79342,576630,9406,540609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001624s ]