SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499436 LIMIT 1 [ RunTime:0.000599s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499436 [ RunTime:0.002561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623544,735845,754448,114408,389686,536955,766540,171824,1039598,80623,655554,657312,934478,356081,1032980,410825,30514,605742,881643,654804,430004,1013117,1023255,781236,240318,373419,752199,282756,964236,1022623,505567,625545,405492,1023594,590479,1026998,702839,163077,688726,887040,610174,168878,420328,124040,575978,641532,93509,431311,636434,213475,660647,697590,674651,491813,621904,141038,534719,685651,633220,586313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]