SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807904 LIMIT 1 [ RunTime:0.001146s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807904 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118207,1037265,113428,989679,189220,3585,421474,883223,273021,169820,280655,266985,716040,69513,539033,820184,157940,768913,140426,730658,342790,810158,302912,283486,208066,1033281,559694,326676,340952,285105,392586,599860,598287,998311,143750,613535,220472,495626,78178,883782,417286,452449,299719,891977,679658,127331,251872,430716,987538,544911,701946,747165,707058,327665,764703,726994,573895,865244,566226,21540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]