SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522941 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522941 [ RunTime:0.003821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257165,114453,129977,427341,44403,58101,1029108,601081,158316,655640,905435,443475,511868,557002,158664,594879,123442,960765,991241,291282,525288,945923,528640,166644,962505,49676,451384,557276,566459,430413,701584,679016,376217,988716,70132,357973,409566,613506,245106,870724,797724,196368,774485,121150,12943,940191,941680,432209,529374,670729,924284,654091,203266,174265,875853,821782,99357,519359,738381,933927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]