SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485011 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485011 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958426,814090,533698,497874,361224,433640,205299,346091,473637,252784,438220,695073,337873,102396,10369,164782,364016,550885,797793,795175,92363,212121,323252,861714,570018,177642,556900,777523,191116,5499,930258,495517,1022689,999322,216510,673451,313977,635695,1014389,596462,228216,1015982,71392,948713,261551,805309,223276,125899,643332,294623,147224,539982,211061,747681,643071,975796,617896,500608,30539,1034127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]