SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395244 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395244 [ RunTime:0.003276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182789,304018,558041,689700,1010942,142459,444393,455378,390663,502587,216554,423625,257793,825031,679848,579909,528835,586875,826910,364677,305696,117283,6080,558473,798033,261318,516879,839193,584818,49993,535377,949831,490284,840066,231131,966369,185747,199365,349252,847470,680775,421442,1003660,90242,764005,223899,1000549,152064,609539,160292,368692,299364,318822,360489,263020,745361,687857,455472,348924,411239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]