SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502184 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502184 [ RunTime:0.002177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39691,122492,272182,433544,672270,986767,268858,697886,892372,574373,295637,578111,520762,1015651,836393,61652,90186,966424,255318,210338,421075,176497,859555,423205,320171,348595,536643,358105,646536,282533,392155,46823,947147,216139,762695,891393,841861,224353,108249,339180,961264,327205,614400,155415,247393,885953,648359,898060,144229,817656,112254,343780,966193,708235,214817,593923,671094,187600,754340,958412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002287s ]