SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261414 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261414 [ RunTime:0.002316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211054,124213,468438,1011333,283258,80593,747865,101814,687763,827252,13728,810203,236053,352829,878739,802832,190031,128029,915613,1046165,445439,1000310,472905,19111,225608,323853,827467,654432,554071,707943,343008,292402,253646,199826,763060,237366,909604,256482,96677,759173,591127,777831,91973,568721,893001,438626,406291,304925,568422,338075,689762,318005,354559,639429,479277,20714,985161,540083,363696,655447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]