SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001738s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410246 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410246 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629087,731221,431317,826347,882912,34493,265920,888998,485423,681815,469394,552740,338552,544336,839462,372927,257366,405982,90532,919307,334090,177006,1001769,4373,165148,854925,938169,449053,1023667,955893,435852,344140,108076,325130,750979,729526,812402,842139,403919,614059,595637,17596,949040,292662,913142,226911,612438,458413,1028439,357010,217798,472659,239143,444831,808646,14235,279788,479679,437694,754047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]