SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110320 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110320 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57048,661002,83920,734281,33219,8006,962531,323448,531893,395368,103449,1007409,325259,938396,260063,911088,138616,390924,601076,607310,721778,1020611,124635,950348,232916,845771,417715,719394,371205,242906,316572,756342,794064,642020,779619,1026378,723934,649465,155001,881886,432508,430973,1021664,414583,725615,463521,526399,628577,993276,668395,532058,139272,583378,741839,772544,973212,253110,906748,727810,73464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]