SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501809 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501809 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150706,111026,474060,673992,40800,41024,62709,891890,711234,186202,529508,306802,732147,12985,789860,416876,969155,163247,460439,232454,374748,192313,185076,645262,739638,523159,1042287,704670,777548,335003,148958,289017,784177,193027,644826,544605,911266,508164,87266,790998,52186,940457,952351,92471,766868,617339,399260,67671,1039375,964759,228619,930876,242859,43718,137664,318568,552898,657328,307795,251441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]