SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431712 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431712 [ RunTime:0.003371s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609984,769717,449478,761932,454500,136689,553936,620913,718123,308057,688102,450890,937416,176410,492243,819185,640500,545939,256587,665256,524050,675242,165780,918935,876184,343224,1033499,152850,834537,229196,103726,175103,218744,423031,390866,700721,852397,38846,133466,892809,64254,230914,191400,976476,915338,973152,241778,24761,602984,475020,381,877511,587622,123046,175546,2993,43157,58327,165184,250256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]