SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310914 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310914 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97396,704877,998488,1017263,199204,106416,648713,683234,936854,866968,694096,805229,1019130,622426,460803,434865,530415,838492,673631,706969,969043,54546,182300,267872,724867,530165,376057,322844,1037196,828270,516971,641582,36749,898521,915772,483367,787761,724576,342856,393118,375474,118629,960484,433894,1028920,318267,48115,78492,821560,460570,299455,972700,784936,335061,934199,987978,530568,565330,469423,43481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000913s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001486s ]