SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405518 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405518 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631400,992186,452788,581402,827687,543996,110875,459792,729473,972776,645546,996747,206415,906344,416127,144856,95067,439603,256436,811727,203380,682004,328672,425900,854399,283307,807158,451608,921498,320296,1012192,81524,601655,333160,245122,314156,568310,112041,219376,305288,869436,819547,434687,317795,982884,457042,866822,573780,163239,704191,285589,183485,198353,893315,766402,430823,869912,257394,975749,149666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]