SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002645s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511382 LIMIT 1 [ RunTime:0.002143s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511382 [ RunTime:0.003111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753406,355472,361916,51384,847686,162604,975109,112653,532307,638332,283810,422965,239161,164413,443687,946306,851866,430863,102572,84137,861296,635694,827886,740042,715498,483051,285127,112608,57542,188471,582028,440473,30922,904851,260567,906754,709780,602398,84175,879723,31614,698010,288982,293286,182205,553010,158879,456864,985493,990219,86495,674134,766880,164544,104286,71037,446952,54028,851822,83686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]