SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001762s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 949704 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 949704 [ RunTime:0.003050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520551,697339,312816,65301,987458,340486,933232,292083,1008055,499949,800373,328537,1010549,1013488,33775,519896,273524,721224,279659,455887,369757,135551,554133,151615,449906,240474,183425,871892,268561,103330,977074,1042231,688203,926046,910261,550566,130921,951741,656465,325787,106692,803964,111825,73038,798261,838805,364502,469,753146,430349,1041339,827483,232270,100543,1045996,877665,239831,80824,688907,609119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 949704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 949704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002810s ]