SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98589 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98589 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817308,495365,442812,139788,778627,453996,653889,653989,235203,884631,691383,110717,1033444,464530,870466,894437,342940,31078,876088,867900,453651,308589,195232,198232,235183,1008208,236058,12838,507794,487437,1016827,971198,1039487,239220,565892,536838,201515,782601,80440,1025674,718181,918678,998590,411652,494321,810590,82549,226706,166092,913787,881637,546615,282035,1020946,211446,991000,200512,632569,881160,245116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]