SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50565 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50565 [ RunTime:0.002465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009039,475323,948747,175396,475105,567680,666911,748555,389247,954209,739065,111655,8109,919130,375024,715367,949979,914191,848119,224675,878953,793332,932730,427475,58872,197131,28987,450496,542765,124293,252367,392459,209930,101025,159046,786696,475154,300497,829114,69697,593505,165034,777605,1015950,359312,560297,749306,122698,650687,87461,452523,652589,838442,599709,997955,467859,16003,778347,413182,160414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50565 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50565 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]