SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47572 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47572 [ RunTime:0.002899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712408,673066,97668,346001,178505,818551,716880,655516,411042,571902,631926,427008,202861,729238,498712,687394,270872,530136,967423,1004161,807428,61410,608538,344505,441429,577581,966205,268715,556019,689392,299540,442396,353306,102332,505506,265600,304884,363599,464150,957898,341232,800064,876488,923879,225895,589665,841395,1048874,769837,1040742,437388,811260,1017666,896733,875428,1003971,420824,56134,856610,886021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]