SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554318 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554318 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979064,823959,306763,141246,222846,143774,228987,990152,230530,863993,217385,946524,51772,155772,879004,140492,533494,807261,639330,406116,556835,439281,511096,572192,698325,725379,272679,453833,980190,878139,1034374,870460,558521,706917,859838,725966,463780,263246,534124,586138,869803,401655,762233,793537,352507,933993,100579,598759,74287,727569,573780,88980,358794,406661,734484,704873,385706,598567,144728,588289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]