SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524710 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524710 [ RunTime:0.002987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464824,387956,660704,690743,847598,790158,566399,922376,962061,155232,705258,215753,145932,783052,620891,301911,452735,103516,108766,295024,965048,315943,1015369,861969,28780,887195,938101,665171,559738,420307,959743,366907,50707,289025,277699,1027286,986178,658504,168546,830234,462098,1044762,919252,355639,473225,785526,43040,453495,331289,936169,852104,216056,939104,1013601,845626,300430,595881,828134,677335,1041221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]