SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001936s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046644 LIMIT 1 [ RunTime:0.001685s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046644 [ RunTime:0.004114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440616,358653,693909,396144,788426,46319,114643,341367,64424,196362,788305,266678,427411,558875,107840,325336,280860,690876,296939,515395,462159,222093,788478,334828,43978,415092,968506,283595,642700,833783,804377,131884,392497,495238,227287,20179,514854,307521,479935,410140,830132,26210,591099,387011,68618,263373,640577,471660,104718,777569,851124,1045772,134074,999520,654397,99098,366637,600065,443771,158369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004423s ]