SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341201 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341201 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868277,275083,296925,13556,202416,915729,996392,931811,167499,699879,554886,805138,1006770,815483,180896,675469,620422,39358,250411,818091,151817,878392,158487,425808,777960,251938,105265,419301,1028541,1042095,318474,1021069,238923,821414,810830,836025,525592,708038,858457,491827,188176,792896,49132,630242,90285,253880,717352,696677,228805,642808,351084,657674,836852,1038221,417086,766093,540332,964161,797469,452550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000878s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]