SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407890 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407890 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614443,491416,943831,598304,924423,1015150,826022,145204,489928,504109,1036339,366369,1015631,579455,824183,836965,84114,454428,450410,7881,167768,312496,155932,173374,398101,611455,192283,682596,149451,573196,171052,512566,587,498591,262362,285055,129952,634790,314696,730859,239785,710283,317548,985405,464509,133891,158971,288131,448123,901093,72387,270838,640112,1001664,205308,120399,697158,39770,701870,594593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]