SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445485 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445485 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495086,1024607,490108,317511,367488,715663,836817,23377,8651,562228,39755,552942,338549,946720,962147,137074,887287,185980,474103,176889,844283,970258,975010,267977,264970,166223,217382,724675,16404,435009,129011,451894,318626,846272,887234,1003267,164613,53879,957056,170987,230076,125038,732205,403306,555491,593338,146440,948095,764886,211666,107756,944071,205320,1029953,1008924,126836,755930,398203,889331,444259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445485 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445485 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]