SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404172 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404172 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929672,746782,521913,757689,857659,252515,519538,406363,259075,129847,765419,916351,220490,3166,87814,373779,538849,995456,607417,1002174,451126,303675,721442,330861,712301,421828,371832,498274,281125,183629,604749,351509,785209,953801,317782,22526,325602,376553,868337,321171,338027,248036,579904,710241,517916,75137,558968,103310,423599,710989,355891,619528,327013,1029105,957983,343425,835499,221926,984992,30480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404172 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404172 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]