SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687860 LIMIT 1 [ RunTime:0.000752s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687860 [ RunTime:0.003850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923241,608288,678394,968800,24280,428501,545308,801188,816205,427711,290495,621975,577005,361910,988724,10883,615636,38385,1001993,515850,819921,698194,527279,1007282,351124,710438,862374,538473,942684,309803,276711,325947,997636,1001983,656519,840409,985133,261792,439370,373224,479648,859567,388990,440295,441984,117579,538598,1027000,141231,909829,216797,530641,478665,883423,198318,129072,167467,70559,445547,109211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]