SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502311 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502311 [ RunTime:0.005621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895401,206856,279325,792880,860034,176836,321932,254082,759864,374873,58740,449473,227578,651415,841897,483902,828003,386792,501273,651774,818426,880418,88736,640242,862646,219913,82260,642877,922001,427159,326853,948291,211320,973861,352931,570327,492192,193064,342573,208427,486944,269373,512090,586470,889667,180087,443884,202701,575781,622374,838423,848568,606144,459516,983664,866024,1033376,376105,118484,933933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]