SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464917 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464917 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994936,289831,710428,838354,891909,570953,189835,407845,455238,488797,734473,902390,680858,298033,483649,723083,175474,758239,449186,213955,424116,261600,454548,948852,272820,290872,240485,457952,952299,476775,849699,508413,676511,503397,103112,264613,511818,619761,205746,296510,833665,253192,256922,962245,320137,402418,778286,895165,174099,944009,14502,909496,663101,820301,490070,864335,60107,219137,675482,96116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]