SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685212 LIMIT 1 [ RunTime:0.000537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685212 [ RunTime:0.002243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532987,573684,893433,588363,959390,869941,532509,83477,297587,441302,1015273,113913,235372,924328,179054,205355,826974,627998,366955,707878,898874,761585,863234,866509,543857,1005484,844988,382932,618329,441285,600622,407831,548964,751041,1040086,682193,366338,151447,963801,15417,391270,952193,271339,696523,887194,306299,107764,424116,324927,4067,579639,497373,1042900,747420,865074,259568,293113,968945,190087,75165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]