SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034475 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034475 [ RunTime:0.004506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350683,43634,690704,70451,401553,937727,550303,39600,624411,846804,283579,464829,679765,82518,406598,38792,905829,54469,85768,417257,486244,467387,567084,576689,195974,549483,696408,572370,543657,8539,809921,235511,209825,878640,337991,1043418,267280,142281,498104,812501,942698,822251,26284,993682,600187,567764,473620,92214,18902,459399,188953,441031,437521,142051,112682,1011201,556730,705096,571205,140927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]