SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564750 LIMIT 1 [ RunTime:0.000618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564750 [ RunTime:0.007315s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26401,628006,225868,908968,349783,53435,1028448,568171,741006,47348,349085,100954,785301,697678,104981,565659,820734,60995,635171,31957,901684,245282,552402,263972,8540,71097,993021,110596,658728,231980,734085,743035,956574,871478,422935,202984,765247,692810,280967,955218,947863,549447,1031702,267709,214157,927372,374394,24726,318824,969079,162454,104890,332875,1003711,162601,204380,872117,867601,408997,378836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]