SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583781 LIMIT 1 [ RunTime:0.001212s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583781 [ RunTime:0.007115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818760,41079,875550,989895,187186,106294,321937,387553,314085,794057,881344,121372,712643,799241,202296,265051,180831,783121,399516,249521,342817,1037963,788815,444612,402918,486915,901853,335046,627210,678346,506300,757143,101669,433640,937394,720894,20598,224958,962549,1033792,129770,673637,361222,94525,879950,391539,107100,410529,583033,247144,929052,454248,529459,886922,991316,411833,121381,327644,425135,359077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002362s ]