SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198053 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198053 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778705,945964,19499,48927,19262,768754,638036,706079,544973,938242,720800,11162,605586,435602,991158,426547,176668,963356,241058,614361,477755,942913,271946,970550,841685,685301,280742,756881,289903,198492,744627,574935,731928,395279,361868,559984,682459,578890,83093,496906,45782,778750,607754,233843,141286,524348,1039342,906313,356201,133701,1018535,658742,619710,734801,643142,628265,20586,1022021,3521,270716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]