SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301447 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301447 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450940,1032933,435219,651718,1035154,328248,460567,167893,324560,199442,45621,304666,126195,980948,841984,295191,481374,355156,864767,1033020,469092,462425,737344,839193,963250,956143,920960,233183,769748,189758,156042,399789,968600,282007,660986,166486,364599,376576,580038,518939,455442,423775,467289,232973,431039,455218,283762,600268,313113,819362,831978,520119,746683,824299,364016,446960,1022340,425432,523656,220550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]