SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489575 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489575 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344480,506246,663879,514762,638852,1012248,340943,155699,917898,690934,909935,586777,34433,610977,141735,201451,947510,509925,232582,1027721,852545,643099,666589,142817,315103,1033189,741349,260271,19432,408928,776987,113802,458818,637142,338506,274075,497944,413654,798881,300274,731323,198480,328953,356732,554565,625388,624504,311647,1023253,316693,255141,285566,770833,58265,801357,521550,19174,431802,774361,927744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003282s ]