SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 940308 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 940308 [ RunTime:0.003392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499836,97388,62596,200303,1047807,631209,286684,897422,849692,793739,560478,957705,202764,1003189,625073,432986,63789,519933,548526,790892,68536,367099,488611,642469,296384,24385,583866,296334,1031129,546799,29273,673778,138442,993675,742480,606540,961395,1023109,837745,749221,372507,534149,241255,176505,731983,288227,174839,847607,579314,78578,931059,114220,802268,360334,918,660277,5226,537872,1021507,939525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 940308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 940308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]