SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544086 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544086 [ RunTime:0.002485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284110,483142,310076,249228,694944,787794,357083,57649,53838,72248,53235,78221,870008,126550,910039,908148,800649,605014,443288,926883,298800,481706,1011594,743731,645230,695423,646709,212079,614235,822085,638441,216696,872053,709411,343406,727317,959329,804708,541396,767410,267093,884237,961726,952528,808579,641897,738202,225292,342018,1040804,812956,523316,538725,560218,442250,601351,273469,76737,196387,195579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]