SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581978 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581978 [ RunTime:0.002452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551787,130038,373300,435500,795644,345568,850788,783343,329609,918051,352390,63030,8923,700716,899575,5144,491032,201584,179759,828231,606823,754340,471352,342144,941990,730534,57090,114642,247804,285043,834726,380067,296891,766016,838180,111152,254655,602659,528246,1031896,76922,551222,135889,70408,827486,821514,675996,926408,714428,1021796,191693,910071,701285,233430,75234,1040814,547492,686021,636200,240489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]