SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456409 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456409 [ RunTime:0.002656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839714,700206,757053,1034705,98992,697535,381235,150118,403688,652514,683262,590243,1012151,1045101,646389,909899,639164,209439,92986,846268,19612,242069,835041,155585,187241,25372,544818,675112,559932,613585,487235,768997,235373,748118,994000,543630,102361,681422,662263,255430,957660,419775,66605,496323,576440,575699,840283,79360,417854,98892,924370,124821,397348,300852,263756,885933,90308,876744,461626,561350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000771s ]