SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456911 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456911 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414025,112711,121635,132890,622870,1005934,359777,998269,625462,432680,1009445,912061,438935,287000,738347,323111,67857,466070,608564,1012353,157364,432495,987399,892893,150869,219065,640404,552693,338529,567972,848488,849959,120608,421137,708968,508927,119993,430821,855196,144398,333777,226277,433168,1045213,202707,627229,979282,858354,221323,537546,658185,542160,78581,121803,998615,47262,520498,536846,525076,694521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]