SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313864 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313864 [ RunTime:0.002026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268927,325854,268678,597303,53479,208797,389304,638885,1004424,705753,547096,50697,819181,102397,99229,425804,523551,314525,523180,949174,672836,966891,73008,940393,404509,542239,477258,731817,972643,170053,60789,504008,806661,751941,88184,342295,927125,762840,696432,1012130,144250,490766,877564,589277,469936,7169,719294,456155,1004292,356388,4754,297032,751235,1039665,875720,872153,6935,542365,929218,865594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]