SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 147528 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 147528 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170597,884581,766281,111006,846348,598041,360138,704034,726340,458827,838857,124626,468432,639373,477230,709538,482214,839801,132439,295093,284240,1006572,394134,70309,104025,678992,818652,783248,155839,524801,894679,305015,256887,288830,169293,1012928,515680,761452,650846,153333,701577,833613,87639,253393,798718,984146,230393,426366,457182,674216,78005,65831,466077,875798,561988,336400,457987,375369,271777,572084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 147528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 147528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]