SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101819 LIMIT 1 [ RunTime:0.000648s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101819 [ RunTime:0.003173s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964621,477655,39442,390292,33956,502569,120008,305594,914580,122151,614217,449810,497663,376932,897595,674874,829404,652592,526559,591745,791870,28310,180439,378243,48690,118466,820786,594371,69239,496582,606401,57846,575628,365997,122557,339976,619351,783591,881778,881836,237588,265096,66365,892546,388967,696767,305471,932857,288532,748974,906507,949015,231694,411693,356929,71403,172626,504313,168510,184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]