SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301974 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301974 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509127,676584,1041235,1037352,72927,364834,350743,764311,661609,439463,691489,5264,174065,725894,1013353,372761,5050,27879,970975,129337,934981,882740,51043,856431,599937,818511,329695,506741,7548,985558,339836,569466,1008367,904736,882327,847470,4698,639619,570984,966882,331300,204151,281997,356380,399631,1017514,830748,196874,730948,164399,529362,544963,220385,269135,643198,664432,741058,537396,924548,584990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]