SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44001 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44001 [ RunTime:0.006576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131311,382390,542627,260631,918187,38182,106449,34803,567195,426679,280474,238593,727935,125132,450656,125885,497555,922085,116510,735309,846307,230098,936339,48782,669681,786129,1043765,219005,474497,451469,755652,769977,898397,831692,498423,1035726,642794,510810,264200,359601,848734,336728,583412,899089,293267,942577,549182,760549,454585,451882,540919,1018292,745876,23060,353265,722433,342515,697628,870986,254972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]