SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023024 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023024 [ RunTime:0.002654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731632,1046094,1039324,38265,84668,488259,119876,820718,954435,989562,922690,474296,251951,196842,301151,21837,20565,730899,54748,1031563,131670,442582,384831,793312,693218,483996,6807,806023,13658,631510,489791,731102,290891,832368,97273,994413,139055,640386,69418,845473,753510,284330,401299,80968,859776,91626,306920,146921,730179,382493,693415,62578,501646,306081,275493,211008,494130,223757,656219,332840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001525s ]