SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002504s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502785 LIMIT 1 [ RunTime:0.001695s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502785 [ RunTime:0.004274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860171,240018,64636,943328,474414,958100,997633,787810,604917,16300,478388,440431,764083,54851,348921,955065,282877,592306,14993,1030776,444232,550217,778288,545072,775512,804263,1024056,511090,864043,988883,767458,872809,11034,868591,34440,36010,200632,174382,486571,694282,827234,182450,905370,297492,85015,723238,316836,794448,434213,786872,722373,245702,546526,579245,621944,282096,811920,606238,763496,821097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502785 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502785 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]