SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522400 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522400 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194921,966765,748014,777418,684977,103052,20402,804174,617483,924608,72713,715420,783760,816022,647210,867743,270065,38618,611193,580363,939841,35687,937567,167464,383455,393802,85296,136384,631751,828164,135202,318451,697193,638251,787761,524611,546726,238100,912090,160616,745651,916557,807606,493439,950899,348529,75,583005,541129,921434,489603,502661,317907,501737,844222,721374,934043,1044020,412644,845585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]