SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474976 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474976 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243449,1033124,1038198,136883,310807,811740,678720,307186,883814,417916,554170,133612,749041,118795,434128,726207,728837,186049,682128,952654,478475,352495,487182,1030167,587604,620404,465737,205439,459661,590088,163129,870029,591336,157169,35605,131582,939205,164166,203952,222906,925830,755665,205677,296458,526002,141549,863085,137997,460821,757900,986361,303961,1046577,450582,281683,659136,859032,955431,569473,179417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]