SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003678s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481991 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481991 [ RunTime:0.002930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440582,446449,948149,877246,604305,170071,178395,624720,520149,78022,655502,901210,933826,217236,734656,318850,342206,48572,559075,634308,37007,16710,381535,1037445,190059,1004102,850382,858863,437803,888932,35587,587318,128101,713891,86165,299243,874876,392676,64142,440169,255528,441483,885533,471689,891025,168588,1034497,679456,253833,336859,174433,493380,187517,134571,322138,824008,965561,404026,244746,908867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]