SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014205 LIMIT 1 [ RunTime:0.000628s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014205 [ RunTime:0.004042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (867401,271344,148867,329448,556876,689005,207687,708059,6938,402905,663187,847855,297942,953067,890281,488893,451513,164289,470419,642819,315473,762325,886079,535082,555871,1009118,340149,867174,201288,278468,799473,634367,608761,751890,953303,471631,664586,349704,359779,762994,913734,473242,660847,62455,613403,846298,961260,963482,878571,633759,677554,120561,168818,255755,115372,907425,191566,706495,329696,324666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]