SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455425 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455425 [ RunTime:0.002272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003547,794264,541336,1012909,577623,746197,586829,797070,1014242,681879,894836,381028,505495,269914,1014904,809529,839709,107082,444801,4009,498773,253124,727615,779748,776749,990151,847577,979833,280693,153312,789665,761584,502011,41916,645721,142540,790606,673517,914291,386483,22566,70411,222971,454812,738585,915464,708759,95241,562004,56298,958743,724530,788064,711416,47853,21003,755056,542584,1016483,385968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]