SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397612 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397612 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048773,392164,19884,1016120,600408,702338,657437,1044676,333223,727122,424237,295402,501363,378833,1020635,936388,28812,773104,1006432,802075,178590,725891,541433,62786,381328,122095,873555,503862,900760,385515,596459,238237,491874,116845,407669,383662,302057,825928,61331,414530,216023,588895,8008,490894,43203,350993,297760,1020648,32819,795735,637673,557483,698403,362042,576062,139654,264984,226869,202067,349523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]