SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001688s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027201 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027201 [ RunTime:0.002305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943791,805015,443550,453859,79894,221805,117974,543140,1031642,394734,767532,479592,1029615,810499,1020808,347587,919543,246810,239127,901644,338860,585818,194139,572100,689184,735279,85612,993436,567453,601508,339699,829476,466244,229549,745257,574225,289741,304872,354745,782191,875422,1028585,1005275,582360,556362,172180,887126,232151,300158,945879,271054,338894,898784,714937,85977,416630,16545,618992,354656,865174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]