SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382099 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382099 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529406,606757,203508,318362,374743,529290,325776,971156,274217,840693,532311,422929,92970,742759,627839,200600,902771,12699,235712,142900,729899,433335,4985,728869,168651,395577,852711,185628,1031297,183586,591612,83910,785111,158673,416151,475667,221132,380456,231056,337301,225616,941725,400431,442662,436539,632911,393591,992278,1043464,773004,36407,93281,321210,974544,191849,135999,717488,122026,493376,643957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]