SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001788s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396586 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396586 [ RunTime:0.002698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157430,853540,22574,605203,357702,754391,517170,831205,71077,5391,269900,461328,801115,101725,301254,807935,757422,132389,322998,102866,855460,10116,247683,578238,207269,672949,754236,576487,929669,850381,1019302,858751,566892,134150,297218,813659,690483,597739,278839,874366,856229,147738,87217,527084,1047016,640775,779265,236355,311511,430423,562979,881552,266463,517886,310894,92817,1016581,715662,596574,727510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396586 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396586 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]