SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289612 LIMIT 1 [ RunTime:0.000275s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289612 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828754,666840,200632,221385,361933,681971,296268,17727,601492,1990,261031,388447,797432,489156,1024244,724665,615594,576548,714128,342622,249345,409539,509089,203398,305049,669947,316976,134341,466079,475261,646067,1034586,348685,952966,1047120,956075,251322,758853,597719,978683,353872,249425,247849,819257,276060,380098,644764,1024954,262427,928175,120029,304226,355755,952017,857152,405910,59240,137672,270009,709466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000376s ]