SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434253 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434253 [ RunTime:0.002359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289859,583801,387128,49797,642794,816030,727222,184554,41604,466991,266025,877471,21932,139549,38771,969928,685184,447946,720821,342062,754401,992565,1014243,651736,928238,933745,952076,69704,195118,217097,173015,757780,225896,16819,501535,685003,979641,424034,62940,525594,305238,846533,909397,596938,686264,775015,603862,427615,860015,258555,1022076,683706,636749,513673,439346,334109,39820,755744,1013513,107938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]