SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334481 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334481 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801842,74940,69650,521986,265307,480618,973655,65717,767235,686775,1036959,477220,513027,1022900,921948,353886,10785,399319,833569,474550,662835,642025,313000,836585,525563,1048006,481657,800513,637614,639472,107664,512254,499414,366215,247196,135379,676854,910607,156402,456915,511321,585433,193931,404138,516194,1012700,968898,755952,223696,949835,185736,142492,802976,932078,881060,424974,91409,147263,338072,179439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]