SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427860 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427860 [ RunTime:0.004943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939679,27065,753759,813529,622001,540848,914521,442963,127684,20950,933626,400265,221123,854120,406268,270133,506363,852619,643125,931218,327185,903434,865603,909854,326352,391106,663181,605196,975869,117801,127549,1041359,22197,35342,29561,468348,46956,1013036,501808,514177,61778,116459,222504,924917,31786,279593,369593,823400,511086,511011,580138,739566,177734,701252,486200,507387,303170,629958,493200,398354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]