SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439206 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439206 [ RunTime:0.002156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016843,134075,483964,814217,895173,255518,299435,865126,678864,1024410,360906,159362,216538,423435,208464,285644,1001985,328460,830735,220408,567591,288146,409202,362963,800135,212790,1019786,44330,750709,913184,855146,855444,58603,510160,632182,598144,451983,893499,577318,822058,159959,278373,840121,466667,340134,120273,973427,889515,579974,903936,679538,890850,280811,790372,818852,1007072,459685,287680,25829,571408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]