SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554480 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554480 [ RunTime:0.002103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92620,166682,243465,266757,58099,654736,193805,481120,508736,659916,337308,891488,274009,940300,607457,727928,848622,699588,821293,386557,448841,598201,325158,665065,753362,730934,1033228,310107,59565,955316,1040672,883454,854847,280580,272483,114954,822608,891888,410342,522138,752347,31053,292921,332951,764516,104287,647858,497489,1024513,135195,77100,307523,618467,471008,406695,742606,813547,847274,443635,530226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]