SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468072 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468072 [ RunTime:0.002479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450727,79894,42867,869927,378393,479016,300595,61695,280727,968771,910338,268838,448301,219009,896649,90023,248999,564734,156890,222990,184290,425690,293563,1014311,744802,125533,634020,280222,341618,83811,340134,620215,829616,12700,1013721,476585,733920,395127,447411,221859,678835,529048,1013432,580114,989147,189774,458544,438832,277972,492914,910468,719663,922295,796547,1004003,121516,939185,158559,819039,3360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]