SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401778 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401778 [ RunTime:0.002448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295228,669040,458165,266402,637253,279940,180863,1002218,163883,717161,64955,142422,367123,305062,867404,785609,128622,878174,584040,957109,214135,890925,593011,187124,135050,245889,105989,638592,201740,400580,613577,778389,483107,864490,1022525,799834,971778,232335,448196,939511,890024,1017097,372684,215387,153760,903052,818574,313358,608525,595936,1007083,230104,797579,301142,51473,1011670,37589,673806,135516,1042137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]