SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504095 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504095 [ RunTime:0.002066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193980,210670,786403,515978,1037735,190166,336125,791929,1002465,609751,563912,923359,878166,1028928,342365,1004401,832865,764505,34237,35574,699902,928572,619187,388824,248025,137363,17407,491749,836047,462011,859510,36770,983487,522532,134372,406076,571270,594786,621122,496104,911891,285887,754527,682058,997229,109031,644143,879384,376051,124396,973754,724855,505423,970489,315922,558181,290352,256837,208789,3874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]