SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003615s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36794 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36794 [ RunTime:0.002642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568754,1017580,1028507,19802,1020712,429650,146467,141565,652361,238266,152823,625043,670779,411122,868007,773578,573256,944188,860865,303428,108955,834514,666668,206269,461620,14785,407454,813215,40676,417598,982035,127305,142083,462456,243388,951755,140751,434991,840163,835010,44904,598373,110647,104802,756791,73530,285960,278086,515580,84359,528332,893721,35631,904522,131339,804186,671660,535570,489933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]