SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037370 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037370 [ RunTime:0.003083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871014,95305,754746,134301,358901,355066,11591,889382,735817,336481,536081,696554,229381,572067,949877,577942,635386,674903,806544,174667,245457,665706,476401,577373,940844,42066,884398,20441,407324,466983,780311,100011,155052,197336,112174,104429,474324,648533,155079,508751,891060,625987,821700,821114,109597,632521,965433,408893,74215,181598,313553,688951,977311,558995,542489,601872,37514,644757,490762,888088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]