SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543811 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543811 [ RunTime:0.002108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323690,571254,456075,1011465,1047771,846763,579602,1022138,604056,262357,788255,622351,567374,644817,880265,920980,741392,440687,742191,441288,852688,943199,590940,128293,546644,536450,288978,742304,809726,188130,498077,888850,257315,963721,928272,551373,730701,731504,155244,752905,654391,525154,951961,458769,643100,407369,866721,6433,560511,41257,989795,900602,83509,626511,21165,542880,1016591,802309,923798,858532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001851s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]