SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984615 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984615 [ RunTime:0.002729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400623,212088,873246,309089,703181,854580,1020512,288550,389713,593544,1011305,831294,519149,918525,126824,468426,768405,414794,175399,544985,326496,721240,918745,407183,887089,512848,488021,403201,569210,137090,602841,794303,978214,851200,953347,470666,45144,299775,953701,461403,865343,647389,1023858,331586,101645,406597,540054,40368,990094,1541,286129,415199,698551,357324,994533,94185,379377,567541,592053,1048444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]