SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039064 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039064 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129930,161566,21607,891701,958984,927681,1046033,720555,206933,18602,728521,604781,649235,886984,744014,1009149,254252,856709,512825,794336,637614,989785,537884,283211,902524,701543,139363,898696,303208,970799,331696,14751,285113,708423,290093,647874,760662,239548,443890,77071,718623,201986,282879,883415,440269,345138,575197,684948,782488,976720,462724,942948,76819,327817,346155,247933,87415,659809,555576,139074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]