SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020412 LIMIT 1 [ RunTime:0.003740s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020412 [ RunTime:0.002303s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384975,953504,612528,241055,539299,15486,199798,491264,313164,711633,277795,191648,505889,157257,39647,576669,419911,199998,759521,622022,38369,939043,152316,54862,162900,217872,92099,1010164,633729,384211,42272,223314,9656,410303,489687,115877,897828,770186,995734,673191,115354,21678,3829,850349,456158,409588,471542,578847,229323,1012278,653037,910554,487543,440504,113859,95368,238850,735504,705353,795088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]